package cc.zy.base.businesses.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.wuwenze.poi.annotation.Excel;
import com.wuwenze.poi.annotation.ExcelField;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.format.annotation.DateTimeFormat;

import java.math.BigDecimal;
import java.util.Date;

/**
 * 233网校登录
 *
 * @Author hutengjiao
 * @Date: 2021/4/6 10:08
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@TableName("t_network_school")
@Excel("233网校登录")
public class NetworkSchool {

    /**
     * 主键
     */
    @ExcelField(value = "序号")
    @TableId(value = "ID", type = IdType.AUTO)
    private Integer id;

    /**
     * 233网校用户名
     */
    @ExcelField(value = "账号")
    @TableField("USERNAME")
    private String username;

    /**
     * 233网校密码
     */
    @ExcelField(value = "密码")
    @TableField("PASSWORD")
    private String password;

    /**
     * 公海表学生Id
     */
    @TableField("STU_ID")
    private Integer stuId;

    /**
     * 学生真实姓名
     */
    @ExcelField(value = "姓名")
    @TableField("REAL_NAME")
    private String realName;

    /**
     * 微信id
     */
    @TableField("WX_OPENID")
    private String wxOpenid;

    /**
     * 关联表名称
     */
    @TableField("TYPE")
    private String type;

    /**
     * 学生电话
     */
    @ExcelField(value = "电话")
    @TableField("TEL")
    private String tel;

    /**
     * 短信回调
     */
    @TableField("MESSAGE")
    private String message;

    /**
     * 短信回调
     */
    @TableField("REQUEST_ID")
    private String requestId;

    /**
     * 短信回调
     */
    @TableField("CODE")
    private String code;

    /**
     * 短信回调
     */
    @TableField("BIZ_ID")
    private String bizId;

    /**
     * 是否激活
     */
    @ExcelField(value = "状态（已激活/未激活）",writeConverterExp = "1=已激活,2=未激活")
    @TableField("ACTIVATE")
    private Integer activate;

    /**
     * 是否激活
     */
    private String status;

    /**
     * 发送短信时间
     */
    @TableField("SEND_TIME")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date sendTime;

    /**
     * 身份证
     */
    @ExcelField(value = "身份证")
    @TableField(exist = false)
    private String identity;

    /**
     * 院校ID
     */
    @TableField(exist = false)
    private Integer collegeId;

    /**
     * 院校名称
     */
    @ExcelField(value = "院校")
    @TableField(exist = false)
    private String name;

    /**
     * 层次ID
     */
    @TableField(exist = false)
    private Integer level;

    /**
     * 层次
     */
    @ExcelField(value = "层次")
    @TableField(exist = false)
    private String levelName;

    /**
     * 批次ID
     */
    @TableField(exist = false)
    private Integer batchId;

    /**
     * 批次
     */
    @ExcelField(value = "批次")
    @TableField(exist = false)
    private String batchName;

    /**
     * 专业ID
     */
    @TableField(exist = false)
    private String majorId;

    /**
     * 专业名称
     */
    @ExcelField(value = "专业")
    @TableField(exist = false)
    private String fullName;

    /**
     * 学习形式Id
     */
    @TableField(exist = false)
    private Integer studyTypeId;

    /**
     * 学习形式
     */
    @ExcelField(value = "学习形式")
    @TableField(exist = false)
    private String studyType;

    /**
     * 招生老师
     */
    @ExcelField(value = "招生老师")
    @TableField(exist = false)
    private String recruitName;

    /**
     * 招生老师ID
     */
    @TableField(exist = false)
    private Integer userId;

    /**
     * 报名费
     */
    @ExcelField(value = "报名费")
    @TableField(exist = false)
    private BigDecimal money;

    /**
     * 报名费
     */
    @TableField(exist = false)
    private BigDecimal originalPrice;

    /**
     * 科目类型
     */
    @ExcelField(value = "科目类型")
    @TableField(exist = false)
    private String subjectName;

    /**
     * 备注
     */
    @ExcelField(value = "备注")
    @TableField("REMARK")
    private String remark;

    /**
     * 科目类型ID
     */
    @TableField(exist = false)
    private Integer subjectId;

    /**
     * 开始时间
     */
    @TableField(exist = false)
    private String beginDate;

    /**
     * 结束时间
     */
    @TableField(exist = false)
    private String endDate;

    /**
     * excel表格行号
     */
    private Integer row;
}